package com.hongsheng.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.data.relational.core.sql.In;

/**
 * TODO
 *
 * @author admin
 * @version 1.0
 * @date 2023/8/11 16:21
 */
@Mapper
public interface DepositoryMapper extends BaseMapper<com.hongsheng.pojo.Depository> {
    //查询仓库是否存在货物
    @Select("select distinct(de_id) from tb_goods where de_id =#{id}")
    Integer existGoods(Integer id);

    //查询电话号码是否重复
    @Select("select phone from tb_depository where phone=#{phone}")
    Boolean findPhone(String phone);


}
